package cn.e2win.biz.cygs;

import java.sql.SQLException;

import org.springframework.stereotype.Repository;

import cn.e2win.base.json.vo.Pager;
import cn.e2win.biz.base.BaseDAOHibernateImpl;


@Repository
public class CygsDaoImpl extends BaseDAOHibernateImpl implements CygsDao {

	@Override
	public void pagerCygs(Pager pager) {
		String sql = "SELECT * FROM cygs_org WHERE 1=1";
		
		try {
			pager.processSql(sql + Pager.DEF_ORDER_BY);
			processPager(pager);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	@Override
	public void pagerCygsEmp(Pager pager) {
		String sql = "SELECT * FROM cygs_Emp WHERE 1=1";
		
		try {
			pager.processSql(sql + Pager.DEF_ORDER_BY);
			processPager(pager);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	@Override
	public void pagerProject(Pager pager) {
		String sql = "SELECT * FROM project WHERE 1=1";
		
		try {
			pager.processSql(sql + Pager.DEF_ORDER_BY);
			processPager(pager);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}
